SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 64105: Basic authentication is not supported in SAS/ACCESS® Interface to the PI System under Linux

DetailsHotfixAboutRate It

SAS/ACCESS Interface to the PI System under Linux currently supports only the none and Kerberos authentication methods. It does not support the basic authentication method to connect to PI Servers.

Click the Hot Fix tab in this note to access the hot fix for this issue.

Post Hot-Fix Instructions

This hot fix requires that you install another hot fix, which supports the environment variable SAS_PI_WEB_AUTH. For more information, see SAS Note 64004, "You encounter slow performance when you use SAS/ACCESS® Interface to the PI System under Linux to connect to PI Servers."

You can set the environment variable, SAS_PI_WEB_AUTH, to use basic authentication by running the following SAS code:

options set=SAS_PI_WEB_AUTH "BASIC";

Then, you can specify and run your LIBNAME statement using syntax similar to either of the following examples:

libname db pisystem host='pi-webapi-host' server='pi-server' domain='your-domain' user='your-id' password='your-password';

libname db piaf host='pi-webapi-host' server='pi-af-server' database='your-database' domain='your-domain' user='your-id' password='your-password';

Notes:

  • Make sure that your target PI Web API host is configured with the basic authentication method.
  • If your PI Web API host is configured to allow an authentication method other than basic, SAS might connect using your other authentication method. In this scenario, some option values such as domain, user-id, and password might be ignored.

This issue is fixed in the SAS® 9.4M6 (TS1M6) April 2019 release.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS/ACCESS Interface to the PI SystemSolaris for x649.439.449.4 TS1M59.4 TS1M6
64-bit Enabled Solaris9.439.449.4 TS1M59.4 TS1M6
64-bit Enabled AIX9.439.449.4 TS1M59.4 TS1M6
Linux for x649.439.449.4 TS1M59.4 TS1M6
HP-UX IPF9.439.449.4 TS1M59.4 TS1M6
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.